 |
 |
 |
 |
#314339 - 06/05/07 09:14 PM
Re: [7.0-7.3] RSS Topic Creator [Release Candidate]
[Re: Gizmo]
|
Master Hacker
Registered: 01/25/03
Posts: 3765
Loc: Saint Johns, PA
|
|
|
Top
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#314359 - 06/07/07 03:43 AM
Re: [7.0-7.3] RSS Topic Creator [Release Candidate]
[Re: SGHB1138]
|
Power User
Registered: 01/01/07
Posts: 59
Loc: UK
|
 Totally unfamiliar with PhpAdmin I copy n pasted this: CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null auto_increment primary key,
USER_ID int(9) unsigned not null,
FORUM_ID int(9) unsigned not null,
FEED_URL varchar(255),
LAST_BUILD int(11) unsigned not null default '0',
LAST_TOPIC_TIME int(11) unsigned not null default '0',
CACHE_TIME int(9) unsigned not null default '30',
TITLE_PREFIX varchar(32),
BODY_FORMAT text,
FEED_IS_ENABLED tinyint(1) default '1',
FEED_WAS_ESCAPED tinyint(1) default '0',
PARSE_BBCODE tinyint(1) default '0',
TOPIC_ICON varchar(30),
REGEXP_SPECIAL text
) TYPE=MyISAM Into my Query window...resulting in this: Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 14
STR: %%
SQL: CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null auto_increment primary key,
USER_ID int(9) unsigned not null,
FORUM_ID int(9) unsigned not null,
FEED_URL varchar(255),
LAST_BUILD int(11) unsigned not null default '0',
LAST_TOPIC_TIME int(11) unsigned not null default '0',
CACHE_TIME int(9) unsigned not null default '30',
TITLE_PREFIX varchar(32),
BODY_FORMAT text,
FEED_IS_ENABLED tinyint(1) default '1',
FEED_WAS_ESCAPED tinyint(1) default '0',
X PARSE_BBCODE tinyint(1) default '0',
TOPIC_ICON varchar(30),
REGEXP_SPECIAL text
) TYPE=MyISAM
SQL query:
CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null auto_increment primary key, USER_ID int(9) unsigned not null, FORUM_ID int(9) unsigned not null, FEED_URL varchar(255), LAST_BUILD int(11) unsigned not null default '0', LAST_TOPIC_TIME int(11) unsigned not null default '0', CACHE_TIME int(9) unsigned not null default '30', TITLE_PREFIX varchar(32), BODY_FORMAT text, FEED_IS_ENABLED tinyint(1) default '1', FEED_WAS_ESCAPED tinyint(1) default '0', PARSE_BBCODE tinyint(1) default '0', TOPIC_ICON varchar(30), REGEXP_SPECIAL text ) TYPE=MyISAM
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null
|
|
Top
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#316980 - 05/16/08 06:27 AM
Re: [7.0-7.3] RSS Topic Creator [Release Candidate]
[Re: Ian_W]
|
Wizard
Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
|
|
|
Top
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#317761 - 01/24/09 10:58 AM
Re: [7.0-7.3] RSS Topic Creator [Release Candidate]
[Re: Grymmie]
|
Addict
Registered: 08/08/00
Posts: 1802
Loc: North Carolina
|
GREAT mod! Thanks very much for this!  A few things... When I try to create a topic feed, I always get: It appears that you have reached an update page without submitting any data. I'm guessing the form data is not being passed for some reason, causing me to get this generic UBB admin error. I'm running 7.4.2. Has anyone else tried this mod on this version? Well, in the mean time, I can just edit things in the database directly with phpMyAdmin. Also, it appears it does not support feeds that use ASP. Is this correct? One feed uses in their URLs, and this is completely stripped out of the URL when posted to my board, even with the FEED_WAS_ESCAPED option checked... How would I strip out from the feeds? I can't figure it out and have never been that good at preg_replace If I specify in Portal Settings to pull from forums created using this mod, it won't pull from them... I just get a big blank space staring at me...
Edited by DL.Webmaestro (01/25/09 11:44 PM)
|
|
Top
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#318544 - 03/27/10 10:00 PM
Re: [7.0-7.3] RSS Topic Creator [Release Candidate]
[Re: nans]
|
Wizard
Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
|
|
|
Top
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#318545 - 03/28/10 06:24 AM
Re: [7.0-7.3] RSS Topic Creator [Release Candidate]
[Re: Gizmo]
|
Lurker
Registered: 10/10/04
Posts: 9
|
|
|
Top
|
|
|
|
 |
 |
 |
 |
|
|